import matplotlib.pyplot as plt
import pandas as pd
df = pd.read_excel('总成绩.xlsx',index_col=0)
plt.rcParams['font.sans-serif']='simhei'
x=df['总分']
plt.ylabel('')
plt.xlabel('')
plt.title('')
plt.hist(x,bins=[100,200,300,400],color=(0.894,0,0.498),edgecolor='m')
plt.show()